DELETE FROM [dbo].[userrole];
GO
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'CTetu-Atagwe'), 3);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'SElmahdi'), 2);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'TWilson'), 2);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'PHouston'), 2);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'SBunting-Graden'), 3);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'TNoel'), 3);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'RWilliams'), 1);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'SRogers'), 2);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'LHaylett'), 3);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'MSchultz'), 3);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'JScanlon'), 6);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'AAli'), 3);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'VShalaginova'), 3);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'KDe Meo'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'SGerrity'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'MBrister'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'fstroker'), 5);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'JCuster'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'JZanikos'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'DAbi-Rached'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'NGrubman'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'DMack'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'LTourtellotte'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'rgrossman'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'sbuck'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'bruth'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'kbettcher'), 5);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'ANadgrodkiewicz'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'MNakagaki'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'lcitrome'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'OYoon'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'jkindle'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'jmancuso'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'athornberry'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'BYektafar'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'MO`Brien-Ali'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'pbeecroft'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'yhongla'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'aayadi'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'epoff'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'gsimpson'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'lbenson'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'rfoster'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'jmorrell'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'fbrown'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'MSchleifer'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'NOtel Belan'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'twallace'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'ESuhir'), 4);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'JSullivan'), 6);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'JCallebaut'), 6);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'AWilson'), 6);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'CScullin'), 6);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'JRogers'), 6);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'JZemko'), 6);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'AAlkebsi'), 6);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'nnadal'), 1);
insert into userrole(userinfoid, roleid) values ((select id from userinfo where loginname = 'TTempInfoOfficer'), 1);
GO